DROP TABLE CRST_AR_MISC_CASH_DISTRIBUTION;

CREATE TABLE CRST_AR_MISC_CASH_DISTRIBUTION                                                                                                               
(                                                                                                                                                            
  MISC_CASH_DISTRIBUTION_ID       NUMBER(15)    NOT NULL,                                                                                                    
  LAST_UPDATED_BY                 NUMBER(15)    NOT NULL,                                                                                                    
  LAST_UPDATE_DATE                DATE          NOT NULL,                                                                                                    
  LAST_UPDATE_LOGIN               NUMBER(15),                                                                                                                
  CREATED_BY                      NUMBER(15)    NOT NULL,                                                                                                    
  CREATION_DATE                   DATE          NOT NULL,                                                                                                    
  CASH_RECEIPT_ID                 NUMBER(15)    NOT NULL,                                                                                                    
  CODE_COMBINATION_ID             NUMBER(15)    NOT NULL,                                                                                                    
  SET_OF_BOOKS_ID                 NUMBER(15)    NOT NULL,                                                                                                    
  GL_DATE                         DATE          NOT NULL,                                                                                                    
  PERCENT                         NUMBER(19,3),                                                                                                              
  AMOUNT                          NUMBER        NOT NULL,                                                                                                    
  COMMENTS                        VARCHAR2(240 BYTE),                                                                                                        
  GL_POSTED_DATE                  DATE,                                                                                                                      
  APPLY_DATE                      DATE          NOT NULL,                                                                                                    
  ATTRIBUTE_CATEGORY              VARCHAR2(30 BYTE),                                                                                                         
  ATTRIBUTE1                      VARCHAR2(150 BYTE),                                                                                                        
  ATTRIBUTE2                      VARCHAR2(150 BYTE),                                                                                                        
  ATTRIBUTE3                      VARCHAR2(150 BYTE),                                                                                                        
  ATTRIBUTE4                      VARCHAR2(150 BYTE),                                                                                                        
  ATTRIBUTE5                      VARCHAR2(150 BYTE),                                                                                                        
  ATTRIBUTE6                      VARCHAR2(150 BYTE),                                                                                                        
  ATTRIBUTE7                      VARCHAR2(150 BYTE),                                                                                                        
  ATTRIBUTE8                      VARCHAR2(150 BYTE),                                                                                                        
  ATTRIBUTE9                      VARCHAR2(150 BYTE),                                                                                                        
  ATTRIBUTE10                     VARCHAR2(150 BYTE),                                                                                                        
  POSTING_CONTROL_ID              NUMBER        DEFAULT -3    NOT NULL,                                                                      
  ACCTD_AMOUNT                    NUMBER        NOT NULL,                                                                                                    
  ATTRIBUTE11                     VARCHAR2(150 BYTE),                                                                                                        
  ATTRIBUTE12                     VARCHAR2(150 BYTE),                                                                                                        
  ATTRIBUTE13                     VARCHAR2(150 BYTE),                                                                                                        
  ATTRIBUTE14                     VARCHAR2(150 BYTE),                                                                                                        
  ATTRIBUTE15                     VARCHAR2(150 BYTE),                                                                                                        
  PROGRAM_APPLICATION_ID          NUMBER(15),                                                                                                                
  PROGRAM_ID                      NUMBER(15),                                                                                                                
  PROGRAM_UPDATE_DATE             DATE,                                                                                                                      
  REQUEST_ID                      NUMBER(15),                                                                                                                
  USSGL_TRANSACTION_CODE          VARCHAR2(30 BYTE),                                                                                                         
  USSGL_TRANSACTION_CODE_CONTEXT  VARCHAR2(30 BYTE),                                                                                                         
  CREATED_FROM                    VARCHAR2(30 BYTE) NOT NULL,                                                                                                
  REVERSAL_GL_DATE                DATE,                                                                                                                      
  ORG_ID                          NUMBER(15),
  MRC_GL_POSTED_DATE              VARCHAR2(2000 BYTE),                                                                                                       
  MRC_POSTING_CONTROL_ID          VARCHAR2(2000 BYTE),                                                                                                       
  MRC_ACCTD_AMOUNT                VARCHAR2(2000 BYTE),
  MISC_CASH_DISTRIBUTION_ID_N     NUMBER(15)                                                                                                        
);
